CREATE VIEW [dbo].[vSoaEventFunction]
AS  
SELECT p.[PRODUCT_MAJOR] AS [EventId],
       p.[PRODUCT_CODE] AS [EventFunctionId],
       p.[TITLE] AS [Name],
       p.[DESCRIPTION] AS [Description],
       p.[PRODUCT_MINOR] AS [Code],
       f.[FUNCTION_TYPE] AS [CategoryId],
       f.[FUNCTION_TYPE] AS [CategoryName],
       CAST('' AS VARCHAR (50)) AS [Status],
       f.[BEGIN_DATE_TIME] AS [StartDateTime],
       f.[END_DATE_TIME] AS [EndDateTime],
       CAST('' AS VARCHAR (100)) AS [FacilityName],
       CAST(3 AS INT) AS [EventFunctionRegistrationTypeCode],
       f.[EVENT_TRACK] AS [EventTrack],
       f.[EVENT_CATEGORY] AS [EventCategory],
       f.[IS_EVENT_REGISTRATION_OPTION] AS [IsEventRegistrationOption],
       f.[MAXIMUM_ATTENDANCE] AS [Capacity]
  FROM [dbo].[Product] p
       INNER JOIN [dbo].[Product_Function] f ON p.[PRODUCT_CODE] = f.[PRODUCT_CODE]
       INNER JOIN [dbo].[Meet_Master] e ON p.[PRODUCT_MAJOR] = e.[MEETING]
WHERE p.PROD_TYPE = 'MEETING'
       AND f.[WEB_ENABLED] = 1
       AND e.[WEB_ENABLED] = 1


GO